UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mG0ZOnlsqq2dXZb6rUN7dRAtlVESdzzvUDv8D0+qq6w='
WHERE
key_id = 'acbc7f76757eb4af06a142bcf86f77449b44882ecf4d3b16302f059facffef2a'
AND (
token = 'mG0ZOnlsqq2dXZb6rUN7dRAtlVESdzzvUDv8D0+qq6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)