SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3819cc9bc73be5741a0a0f0ba2b5aebddf2c3b1e173c82b77ccb8c03add4d17c' 
  AND token = '5z+c2fn/+h2ouqlD2EgNR/KRf9zmHijfPMmgZvcBFgI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00032

JSON explain

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