UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HVVmUyBm2/EP5PVgR1grRH43b2VRqRgzFuXR5Nf0nC4=' 
WHERE 
  key_id = '08a80339e95e75b8b39c1d2cea8faf24f08c63e95e63ae5b75f2f1854c878e9a' 
  AND (
    token = 'HVVmUyBm2/EP5PVgR1grRH43b2VRqRgzFuXR5Nf0nC4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023