SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'a053454d1f67a770130009c12f8236183e1a8c581fd85a61e4bfc6d4e060f8dc' 
  AND token = 'Zlv4nUnk/U3LgtXWcbZoueu2tnTj+2QXvPqiD8Mh9d0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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