SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5978ca0d43d1a074c3b4557c3f7399d87002eb692a6244e3cf3b12ce0705b6ff' 
  AND token = 'aV5zDWodpuHSYROduNIw+eaydeUTxD1NFs7lN5lHfc4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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