UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7a+HsIbbWq3G67VKWl7p0Yhq+Aw3MP8bIwyLu2yWSFg='
WHERE
key_id = '6a914920081f8f06b731d5c609716f87c71b6bef488e72d3b8cfede7ee83c8dc'
AND (
token = '7a+HsIbbWq3G67VKWl7p0Yhq+Aw3MP8bIwyLu2yWSFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)