UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QO5gls+dyZEUWH/n13CLMYtA8QVKH8UKdZfkc8jmowA='
WHERE
key_id = '330decf02f9507c1527325200e9ce297e4984cde5835ffa42584d2c6448d9a2a'
AND (
token = 'QO5gls+dyZEUWH/n13CLMYtA8QVKH8UKdZfkc8jmowA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)