UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lHGIbYTiVd8tYJo5kTucLp93tg1Y9glB7LXVe2gXKM='
WHERE
key_id = '0f5554a4045c8b45c32c083d1df5530e5fe19eb85e4233a24816f93c6536393e'
AND (
token = '/lHGIbYTiVd8tYJo5kTucLp93tg1Y9glB7LXVe2gXKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)