UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mkN61AwxZ1+sITLRaK4Uiw2sAbisTt33BLvOeTtrJ5E='
WHERE
key_id = 'cc67b5f5ab708b565eec2f9d068893f78efe7e55d28685af4c1f0bd47b86453f'
AND (
token = 'mkN61AwxZ1+sITLRaK4Uiw2sAbisTt33BLvOeTtrJ5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)