SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1c148bcce15126ccf5a5c09c8eeca806ded5809fd9c7a30dfdeb56daf9861694' 
  AND token = '3vj3r7AQ15xDSSbVJi8+4RI4LKAFu+CC1jVIKf4gn68=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

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