UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LmlW7uiXhTz186W0Ycon16taK11eRBI6Qe7VMrnyUng=' 
WHERE 
  key_id = '1d6325115165fc4dc7fff430b03df677d16b094a9615cc5ae38d7c7247be5c1d' 
  AND (
    token = 'LmlW7uiXhTz186W0Ycon16taK11eRBI6Qe7VMrnyUng=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026