UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29SdFCBvohiKL0vs2J35imZrF3RvUTvgR5Dy7Syj7vI='
WHERE
key_id = '470e4266780546102eed51cf317f430c841aad6c23df3b5a6c3b92bd9ec6ae5a'
AND (
token = '29SdFCBvohiKL0vs2J35imZrF3RvUTvgR5Dy7Syj7vI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)