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

Query time 0.00025

JSON explain

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