SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cadbde5bbc94f17a3e5f48951bd9f46e9e3e4a119aa6baf5c02c18c720265748' 
  AND token = 'hkJNPoOwcVdaUGH1uCMAK/WHayMyJtJMSSRxVZS58xc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00050

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}