UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H+A97xjAUfbQtYziUGThlm7O/LnB18zRgFxsNV7ZVAw='
WHERE
key_id = 'bb7c56fc5a79ad98eb8eaa3bf058d91966f5478163a8f38ad738e28ef827a25f'
AND (
token = 'H+A97xjAUfbQtYziUGThlm7O/LnB18zRgFxsNV7ZVAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)