UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UTdoisJw2TDHJ/W33HKFCLyHFUFespBqhMDC/r9jkzU='
WHERE
key_id = '10ab4e46d1a36e6a002225aec7fac87b24a82458efebc4837e6b859599881691'
AND (
token = 'UTdoisJw2TDHJ/W33HKFCLyHFUFespBqhMDC/r9jkzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)