UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S7dTDzf9lRYP0zYUB/8HmQ6ZEBvTZSoSl6NifJ1UFWo='
WHERE
key_id = '5062970687578f589799c7e86839b441a54b436f02269a91d3450c4c52d2ed9a'
AND (
token = 'S7dTDzf9lRYP0zYUB/8HmQ6ZEBvTZSoSl6NifJ1UFWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)