UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zF9mSC8Vt6aVg722x1LnVK+TeuRzwIW67IG61/kSDLM='
WHERE
key_id = 'e4aaaaf98164b293d3aa4efb8fc596f56c98c94224380d04647a3260949a74c6'
AND (
token = 'zF9mSC8Vt6aVg722x1LnVK+TeuRzwIW67IG61/kSDLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)