SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6fc66ca144c6a9a8ae32286729f638d08d30f2afe36286bacb53312274065385' 
  AND token = 'TxPJ33P3luAZnT7diKJQSRUaMIlXvo8yqmAZec5AHbI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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