SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '499c5d42f49352232f49bf0f365112e715bdc11f6336ae8ef4fb3165ce8934d2' 
  AND token = '/bUOBfX5IsinydJB3SfDbpySJSGxjhInRTbkMuXuQB0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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