SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1e18d9a84791126d585cb289a56fb7149ab4af9e7d62e3374032f1c15dceac29' 
  AND token = 'kqVIRGI4lRFQ2ZlvbmA4TeVZAseBkgqAysk1iOx49Fs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00014

JSON explain

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