UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2vsFB+B09OvlvJEMpWIe1GggxQGtVcEhx5HiKhOol/w='
WHERE
key_id = 'ded4b56027cce0e63d3b7e3a03a539ad5bd432aba6d85fd22a7e9a11d5bf8a9a'
AND (
token = '2vsFB+B09OvlvJEMpWIe1GggxQGtVcEhx5HiKhOol/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)