UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UI1GfACZwQ8SBggh8rVisbcE6o+f4qO34KFmG+W8cPI='
WHERE
key_id = '1ea46fca1bd2960a489a615e7dafa2ee81ebb76efd3ccad69ab8fecbbca04de3'
AND (
token = 'UI1GfACZwQ8SBggh8rVisbcE6o+f4qO34KFmG+W8cPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)