SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'a52442c2f495091a278e3f24359d1f504aa76a4a549f16af1c5f921d9eee3308' 
  AND token = 'VTCY2bCPeQ4oURj8jEheRKAYR+3EX3sunSvqbw9kmEE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00033

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}