SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4f222e2719670d1d0b10af9f47b4eb25f69d3a6b2e968ab4dd0cfddf27f0de41' 
  AND token = 'KgJkPn2oAyO5kCAmygXzlWYwyDEHqgo1AwaKj6RRmfw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00013

JSON explain

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