SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3dc70e65ec1cc576c195ad9cd1d8deedb0bfd092cfce0b6ae0e86b1b9551a75d' 
  AND token = 'BNoE6zg6BJ5PV3P2QM1FqpQPbMa1hNo2cXj3xPdJRjU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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