UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rojEJaASUJwJUgSlFOiZY0WldI3L9YFz4zKlYxJxFys='
WHERE
key_id = '11e0fbd1f2621c6cfe331612a49b6afe9a7214c256e660c28330924e39de6a0a'
AND (
token = 'rojEJaASUJwJUgSlFOiZY0WldI3L9YFz4zKlYxJxFys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)