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