UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ip7e9V117WMzrTbd/nLjbYqW865H8YgH9FN6uuG7iKc='
WHERE
key_id = '457c8432c356d6244e37c5b6dd68bae88cfe7e67ad8013734cde772c1b1c66d8'
AND (
token = 'Ip7e9V117WMzrTbd/nLjbYqW865H8YgH9FN6uuG7iKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)