SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5cb0e6b237d2e39814f50cfd4b2c15e00da5a35ec9ea300be990629fa7ff3b0b' 
  AND token = 'ynDLUmF4hxlwdf3YGAKU5Myn7nKe2mC3AslJ13ZgTNA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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