UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lFvqbBnNvsKh70nVo1HKfT+47UelcN+b45o6F7vy48='
WHERE
key_id = 'be9f96bd477f54a1cc14c101496b650283b46e385956630506bb80211946b943'
AND (
token = '4lFvqbBnNvsKh70nVo1HKfT+47UelcN+b45o6F7vy48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)