SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1989e088b55e5f8aa0a3b964e4f5028f314b2b7d5d5ef8b2ea73f0b8a126081c' 
  AND token = 'b4s2KCW05zb7GXn6DM7JlbucbyUNqYK4XalkYg+PhFc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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