SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c0877ffd78f8e1a43a4b4a16409d5a39f033fe8f4daeb50ece3e3e2842536d47' 
  AND token = 'fbs3jwRXxcV644pBQ1p/bm0VeEhtWIJ5TqmPGFXPDWY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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