UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3J/D7PeF4YN62z+XoW8e7UyMwF/TdOa9YW2y06+fepo='
WHERE
key_id = '831407247c15876ffa8090f5e3bd48b91a4553692f3246957aa04eceb8933a41'
AND (
token = '3J/D7PeF4YN62z+XoW8e7UyMwF/TdOa9YW2y06+fepo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)