SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7e25bd7f1dc9b5bc3a07e49b25f81528da592ddd47a615a7b570f7b4dc4f1665' 
  AND token = '1RivC9xYAiY9viDvwYd/yC/MxINaepl6iKHnNVTUd58=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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