UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sx6D7UiKdXCE9mILcqm80WZ518OPPgnZq4g5t17kyf4='
WHERE
key_id = 'eba8652caf8e03c142efb013544d12a8f9f458687d0ffb2edf2408f6696a77f4'
AND (
token = 'sx6D7UiKdXCE9mILcqm80WZ518OPPgnZq4g5t17kyf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)