UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xsJGpBmz0kAnSROx2Q6F9Tk/nmfm1uznrIzCfpzjYWI='
WHERE
key_id = '1fc38f98e938c33fb12c0db8e4727e58442636283cc35c8c490caff771e0a616'
AND (
token = 'xsJGpBmz0kAnSROx2Q6F9Tk/nmfm1uznrIzCfpzjYWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)