UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1z1JHwKiCdIBDrO6WiWCTjFCWRW6fw8gUoi+sxOOeYw='
WHERE
key_id = '89ff7b76a199791d7f226c274faec8faf6bf9536181316e6afa9f895e86db576'
AND (
token = '1z1JHwKiCdIBDrO6WiWCTjFCWRW6fw8gUoi+sxOOeYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)