UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UecJvy3p6Zlg0cRH7Rt7067gI+GAquWhFTWqqJHh9Sw='
WHERE
key_id = 'af69cee2b87b7100237b21122bd8cde50d3074941eaaef96cc986dd0a321ad4e'
AND (
token = 'UecJvy3p6Zlg0cRH7Rt7067gI+GAquWhFTWqqJHh9Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)