UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZXOE1EIQr6vut5GvRQgfFXeOZJhyladWE0BUUZocWM='
WHERE
key_id = 'cb49977723f58e4d6c53b8c2d1af5a5fe57f47ad381f89e2122cf214b3aacfa7'
AND (
token = '9ZXOE1EIQr6vut5GvRQgfFXeOZJhyladWE0BUUZocWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)