UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cgWCg6XuTrEWh4hF251A+FN0H6Azch4C7Q2MOqqT0zY=' 
WHERE 
  key_id = 'cac3d342e19857e28051de5d2c003df936f90eb97308ce71bf1771b77fb60c38' 
  AND (
    token = 'cgWCg6XuTrEWh4hF251A+FN0H6Azch4C7Q2MOqqT0zY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022