SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '923a1f7cd362ca555ee6aef4e0ed00858a9aa08bdb42ad05718934b1a61e8efb' 
  AND token = 'oNqzaC2Cpf6iSNsqh8X+7PuGqKKktJe3Ddj3WxUjqYs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00056

JSON explain

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