UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XC5ZFcy6ZTHc1gS13RKvmVLWWSOXhyDmmxROc39JOn0='
WHERE
key_id = '046c78e0559a79f6472ec65249bc4c3cfaa946c5f20cb1c35eaf359e1c6db793'
AND (
token = 'XC5ZFcy6ZTHc1gS13RKvmVLWWSOXhyDmmxROc39JOn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)