SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1509fa9280283908f8990aa0d2284792f60f83d8a832aedcb8745e9dca757533' 
  AND token = 'H7AQFTjpfhgDv6HB3CUrkYGraBy3S8a6ai5ZWo0FGjQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

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