SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '25a097c50a37bc7fcb0e81e67938f95a10884fa661b1a3313dd1bdf7f6de9ed1' 
  AND token = 'A4tmlvW1crI11RuYvpnSLsKt5IucmDgQtTbc22gESnc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00011

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}