UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E0woxnQLP9sJHSVDmz3/FE1i0ePd6BrfwP2hbNVlNew='
WHERE
key_id = '9bafbe4e08bfa487d41bb9873e803759f7e437dbaaf5e256378e83eabfe798d1'
AND (
token = 'E0woxnQLP9sJHSVDmz3/FE1i0ePd6BrfwP2hbNVlNew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)