SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bfdc845de4d31b93bd05462de612a03a985db9c70bcdb32d06c4a4875cd1651a' 
  AND token = '/1HDEUp0YzQtX4S2YS1a8K2oLkil2Nl5xdeyvVbvPIk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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