SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9d3e0bc2fd40e6415f747611b97c23ccfbe6ad9e679d8c49b2ccd83e954c3c01' 
  AND token = 'zjBsJqWDFz0o+wTVOd7dQu7Hc6T1QnXWpTBXLJ4He+Q=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00045

JSON explain

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