UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ErY7fizSzClEbo43v95UPrWBN438QvmmSNYX12ClRp0='
WHERE
key_id = '83cc8e9c78060b3aa78a2f4e65ed8b3edcc675f55e301f23c3d63f2d53d0accb'
AND (
token = 'ErY7fizSzClEbo43v95UPrWBN438QvmmSNYX12ClRp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)