UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3O4vYhfFAE1qfGvoWqCqSVIxCV7hc7uuXXA7LoYTwgE='
WHERE
key_id = '8278a6f367fba1e2269b524a53efcd963d261470bfde3e43c2d6f8bd793c9ec4'
AND (
token = '3O4vYhfFAE1qfGvoWqCqSVIxCV7hc7uuXXA7LoYTwgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)