UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCzkiaF2gV7xJ/xF7R/psrAPsC4bQ5HPSRYJtXdFz6Q='
WHERE
key_id = '7f6597d09b603c708632981d24890577710b8d3738f2f7102291b85c6e619123'
AND (
token = 'xCzkiaF2gV7xJ/xF7R/psrAPsC4bQ5HPSRYJtXdFz6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)